package com.duanzz.mapper;

import com.duanzz.entity.Role;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author duanzz
 * @description
 * @date 2020/11/17
 */
public interface IRoleMapper {

    @Select("select r.roleid,r.roledesc from emp_role er left join role r on er.rid = r.roleid " +
            "where er.empno = " +
            " #{empno}")
    Role findRoleByEmpno(Integer roleid);

    List<Role> findRoleByConditionWithEmps(Role role);

    List<Role> findAllRoleNormal();
}
